2015-11-30 - 23373 - Service Request - open change request report update #CrystalReportsSupport
Service Request
23373 - open change request report update
Problem Summary
Need to fix the open change request report to display all the un-closed tickets.
Admin Info
Purpose
|
Need to fix the open change request report to display all the un-closed tickets.
|
Requested by
|
Jeffrey Mau
|
Issue Date
|
11-30-2015
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
12-02-2015
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan on 12/01/2015:
Find below the requested modifications that needs to be done for the recap 100 report through email:
1. Currently the report is showing past three days data. Please remove the current date - 3 formula from filter and it should show all the unclosed change request tickets.
(The tickets will be in created, approved, implemented classifications).
2. Please add new group classification called rejected to display the rejected change requests along with created, approved and implemented.
3. Make sure the group tree shows all the environments. Eg : Production , quality and development.
4. Make sure whether we can remove the "others" category and display the actual phase like "implemented" or "approved".
Solution Analysis and Recommendations
1. Need to remove the (current date - 3) formula from filter and it should show all the unclosed change request tickets.
2. Need to suppress the splash if it is empty or blank. i.e isnull({tblChangeManagement.CM_Splash}) or ({tblChangeManagement.CM_Splash}) = "".
3. Need to create new formula based on CM_Environment instead of existing formula Destination Group. Eg : Production , quality and development.
4. Need to modify the Grouping formula for "others" category and display the actual phase like "implemented" or "approved".
5. Need to check if all the specified changes are implemented in the report.
6.
Need to validate the data with SQL database tables in the report.
Resolution
1. Remove the (current date - 3) formula from filter and it should show all the unclosed change request tickets.
2. Suppressed the splash if it is empty or blank. i.e isnull({tblChangeManagement.CM_Splash}) or ({tblChangeManagement.CM_Splash}) = "".
3. Created new formula based on CM_Environment instead of existing formula Destination Group. Eg : Production , Quality and Development.
4. Modified the Grouping formula for "others" category and display the actual phase like "implemented" or "approved".
5. Handled NULL values without throwing any error in report.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
2
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Release Information
None